﻿CREATE VIEW [dbo].[ASMS_V_StockChangedRecord]
	AS 
SELECT SCR.*,
	W.BusinessId,
	W.StationId,
	W.[Name] as WarehouseName,
	M.[Name] as MaterialName
FROM ASMS_StockChangedRecord as SCR
	left join ASMS_Warehouse as W on W.Id = SCR.WarehouseId
	left join ASMS_Material as M on M.Id = SCR.MaterialId
